<?php
require_once "Common/database.php";
require_once "Common/values.php";

$result = mysql_query("SELECT * FROM tblSelect WHERE `Select`='$_GET[s]'");
#$query="SELECT * FROM tblSelect WHERE `Select`='my'";
#echo '<h3><center>'.$query.'</center></h3>';
echo '<P><h3><center>Select Edit</center></h3><table border=1>';
while($row = mysql_fetch_array($result))
{
echo '<form action="system/helpdesk/uinsert.php?f2=Select" method="POST">
<tr><td>Name</td><td><input type=text name="select" value="'.$row['Select'].'">'.'</td></tr>
<tr><td>User</td><td><input type=text name="user" value="'.$row['User'].'"></td></tr>
<tr><td>Log Number</td></td><td><input type=text name="lognumber" value="'.$row['LogNumber'].'"></td></tr>
<tr><td>Due</td><td><input type=text name="due" value="'.$row['Due'].'"></td></tr>
<tr><td>Assigned</td><td><input type=text name="assigned" value="'.$row['Assigned'].'"></td></tr>
<tr><td>Requestor</td><td><input type=text name="requestor" value="'.$row['Requestor'].'"></td></tr>
<tr><td>Subject</td><td><input type=text name="subject" value="'.$row['Subject'].'"></td></tr>
<tr><td>Proirty</td><td><input type=text name="proirty" value="'.$row['Proirty'].'"></td></tr>
<tr><td>Status</td><td><input type=text name="status" value="'.$row['Status'].'"></td></tr>
<tr><td>Project</td><td><input type=text name="project" value="'.$row['Project'].'"></td></tr>
<tr><td>Closed</td><td><input type=text name="closed" value="'.$row['Closed'].'"></td></tr>
<tr><td>Line</td><td><input type=text name="line" value="'.$row['Line'].'"></td></tr>
<tr><td>Branch</td><td><input type=text name="branch" value="'.$row['Branch'].'"></td></tr>
<tr><td>Department</td><td><input type=text name="department" value="'.$row['Department'].'"></td></tr>
<tr><td>Private</td><td><input type=text name="private" value="'.$row['Private'].'"></td></tr>
<tr><td><input type=submit value=Update></td></form></tr>';
}
echo '<tr><td><a href="index.php?p=shadd&f2='.$_GET[f2].'">Add</a>';
echo '</table>';

?>
